<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("devildark", $con);
$dateTime = date("Y-m-d",strtotime("-1 day"));
#$dateTime = '2012-03-28';

mysql_query("INSERT INTO report_nojailbreak_total(deviceid)
SELECT DISTINCT deviceid FROM devildark where JailBreak = '0'");

mysql_close($con);
?>